package com.example.finaltool.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.finaltool.model.RangeCheck;
import com.example.finaltool.model.db.info.Range;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author dengbw
 * @date 2021/8/16 11:44 上午
 */
@Mapper
public interface InfoConsultingRangeMapper extends BaseMapper<Range> {

    @Select("SELECT i.consult_id as consult_id, i.info_type as info_type, i.sub_tenant_id as sub_tenant_id FROM info_consulting_range i WHERE tenant_id = #{corpId}")
    List<RangeCheck> getExist(String corpId);
}
